import pandas as pd
def getStudentInfo(file_path,small_target_value):
    data=pd.read_excel(file_path,skiprows=6,header=None,sheet_name=None)
    keys=list(data.keys())
    adata=pd.read_excel(file_path,skiprows=6,header=None,sheet_name=keys[0])
    length=len(small_target_value)

    common_list=[i for i in range(0,13) if i !=7]
    student_info=adata.iloc[:,common_list]
    columns_name=['学号','姓名','课程编号','考试科目','考试状态','性别','是否留学生','学院','考试日期','班级','年级','备注']
    student_info.columns=columns_name
    for i in range(len(keys)):
        adata = pd.read_excel(file_path, skiprows=6, header=None, sheet_name=keys[i])
        student_info[keys[i]]=adata.iloc[:,-length-1]
        for j in range(length):
            student_info[keys[i]+'课程目标%s'%str(j+1)]=adata.iloc[:,j-length]

    return student_info
# if __name__=='__main__':
#     file_path='成绩分析表_测试.xls'
#     from 目标完成度计算表 import small_target_value

#     print(getStudentInfo(file_path, small_target_value))